Version:

Share

Description

You can easily import data from a CSV or Excel file with the Static CSV data source.

Video recorded using: Ignition 8.1

Resources

Transcript

(open in window)

[00:00] In this lesson, I'll show you how to quickly add data to your report with a static CSV data source. From the Data tab, create a new data source and select Static CSV. You'll see that the Static CSV is created with preloaded data. There are three column headers here and then two rows of values. There's a string column, an integer, and a float column. You'll notice that the string values are wrapped in quotation marks here but that isn't necessary. If I were to add another row of data here and didn't include the quotation marks, this would be fine. The only caveat to this is if you want your string to contain a comma. Since the values are delimited by commas, you'll want to wrap the string in quotes, so it doesn't think there are multiple values. I'll head over to the Design tab and we can look at using this data. If I expand the key browser, you'll see the three columns that were defined at the top of the CSV. I've already placed these innotable component. So I'll move over to the Preview tab.

[01:04] Here are the values from the CSV including my string value without the quotes. This data source can be useful when you want to quickly add data to a report, especially when you're in the testing phase. For example, this can be used when you don't yet have a database connection. You can build out what you want the report to look like and then you can swap it out for the real database data once you get access.

You are editing this transcript.

Make any corrections to improve this transcript. We'll review any changes before posting them.

Cancel Submit
Back to top